
<%@page import="java.util.Date"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="com.DBtools"%>
<%@page import="com.Datetools"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
	<title>打卡数据</title>
	<link href="../Style.css" rel="stylesheet" type="text/css" />
</head>

<!--这是个未正常打卡标记页面  -->
<h5 align="center">异常情况备注</h5>
<body>
<style>th{text-align: right;}</style>
<%

/* String nowtime2= new Datetools().toString(nowtime);
Date nowtime3= new Datetools().toTime(nowtime2);



out.println("时间："+nowtime);
out.println("时间："+nowtime2);
out.println("时间："+nowtime3);
 */
request.setCharacterEncoding("utf-8");//编码
String TeaId = request.getParameter("TeaId");
String Date =request.getParameter("Date");
//String date="2022-12-16 00:00:00";
out.println("date:"+Date);
ResultSet rs = new DBtools().query("select * from teastatistics where TeaId = '"+TeaId+"' and Date ='"+	Date+"'");//尚未完善，更改 
 String TeaName="", DepName="",IsCheck="",IsUnusual="";
if(rs.next()){
	TeaName=rs.getString("TeaName");
	DepName=rs.getString("DepName");
	IsCheck=rs.getString("IsCheck");
	IsUnusual=rs.getString("IsUnusual");
	
}
rs.close();
%>
<hr>
<form action="../RemarkSave?TeaId=<%=TeaId%>&Date=<%=Date%>" method="post" >
<table border="2" width="50%" align="center" class="imagetable">
 <tr>
      <th>教师工号</th>
      <td><%=TeaId %></td>
      </tr>
       <tr>
      <th>教师姓名</th>
       <td><%=TeaName %></td>
      </tr>  
       <tr>     
      <th>日期</th>
       <td><%=Date %></td>
      </tr>
       <tr>
      <th>学院</th>
       <td><%=DepName %></td>
      </tr>
       <tr>
      <th>打卡情况</th>
       <td><%=IsCheck %></td>
      </tr>
       <tr>
      <th>异常备注</th>
      <td><textarea cols="50" name="IsUnusual"><%=IsUnusual %></textarea></td>
      </tr>
      <tr>
      <td colspan="2" align="center">
      <input type="submit" name="btn" value="提交"> 
       <a href="checkstata.jsp">返回列表></a> 
      </td>
      </tr>
</table>
</form>
</body>
</html>